﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace BusinessLayer.Common
{
    public class Constants
    {
        public sealed class StoredProcedures
        {
            //Subscriptions
            public const string GetAllSubscriptions = "sp_Subscriptions_Select_All";
            public const string InsertSubscription = "sp_Subscriptions_Insert";
            public const string GetSubscriptionByID = "sp_Subscriptions_Select_By_Id";
            public const string GetSubscriptionByCode = "sp_Subscriptions_Select_By_Code";
            public const string UpdateSubscription = "sp_Subscriptions_Update";
            //MarketingCategories

            public const string GetMarketingCategoryByID = "sp_MarketingCategories_Select_By_Id";
            public const string GetMarketingCategoryByCode = "sp_MarketingCategories_Select_By_Code";
            public const string GetAllMarketingCategories = "sp_MarketingCategories_Select_All";

            //Marketing
            public const string InsertMarketing = "sp_Marketing_Insert";
            public const string GetMarketingByCode = "sp_Marketing_Select_By_Code";
            public const string GetAllFullInfoMarketing = "sp_Marketing_Select_FullInfo_All";
            public const string GetFullInfoMarketingByCode = "sp_Marketing_Select_FullInfo_By_Code";
            public const string GetFullInfoMarketingByID = "sp_Marketing_Select_FullInfo_By_Id";
            public const string UpdateMarketing = "sp_Marketing_Update";
            public const string UpdateMarketingDiscount = "sp_MarketingDiscount_Update";
            public const string UpdateMarketingCoupon = "sp_MarketingCoupon_Update";
            public const string InsertMarketingCoupon = "sp_MarketingCoupon_Insert";
            public const string InsertMarketingDiscount = "sp_MarketingDiscount_Insert";
            //AdminLogAction
            public const string InsertAdminLogAction = "sp_AdminLogActions_Insert";
            public const string GetAllAdminLogActions = "sp_AdminLogActions_Select_All";
            //AdminUsers
            public const string InsertAdminUser = "sp_AdminUsers_Insert";
            public const string GetAllAdminUsers = "sp_AdminUsers_Select_All";
            public const string GetAdminUserByID = "sp_AdminUsers_Select_By_UserID";
            public const string GetAdminUserByUserName = "sp_AdminUsers_Select_By_UserName";
            public const string UpdateAdminUser = "sp_AdminUsers_Update";
            public const string GetAdminUserByUserGroupID = "sp_AdminUsers_Select_By_UserGroupID";
            public const string GetAdminUserByUserNameAndPassword = "sp_AdminUsers_Select_By_UserNameAndPassword";
            public const string ChangePasswordAdminUser = "sp_AdminUsers_ChangePassword";
            public const string ResetPasswordAdminUser = "sp_AdminUsers_ResetPassword";
            public const string ChangePasswordAdminUserByUserName = "sp_AdminUsers_ChangePassword_By_UserName";
            public const string ResetPasswordAdminUserByUserName = "sp_AdminUsers_ResetPassword_By_UserName";

            //AdminUserGroups
            public const string InsertAdminUserGroup = "sp_AdminUserGroups_Insert";
            public const string GetAllAdminUserGroups = "sp_AdminUserGroups_Select_All";
            public const string GetAdminUserGroupByID = "sp_AdminUserGroups_Select_By_ID";
            public const string GetAdminUserGroupByUserID = "sp_AdminUserGroups_Select_By_UserID";
            public const string GetAdminUserGroupByUserName = "sp_AdminUserGroups_Select_By_UserName";
            public const string GetAdminUserGroupByCode = "sp_AdminUserGroups_Select_By_Code";
            public const string UpdateAdminUserGroup = "sp_AdminUserGroups_Update";
            public const string InsertAdminUserGroups_Menu = "sp_AdminUserGroups_AddMenu";
            public const string InsertAdminUserGroups_Action = "sp_AdminUserGroups_AddAction";
            public const string InsertAdminUserGroups_User = "sp_AdminUserGroups_AddUser";
            public const string DeleteMenuInAdminUserGroups = "sp_AdminUserGroups_DeleteMenu";
            public const string DeleteActionInAdminUserGroups = "sp_AdminUserGroups_DeleteAction";
            public const string DeleteUserInAdminUserGroups = "sp_AdminUserGroups_DeleteUser";
            public const string DeleteAllMenuInMAdminUserGroups = "sp_AdminUserGroups_DeleteAllMenu";
            public const string DeleteAllActionsInAdminUserGroups = "sp_AdminUserGroups_DeleteAllActions";
            public const string DeleteAllUsersInAdminUserGroups = "sp_AdminUserGroups_DeleteAllUsers";
            public const string DeleteAllPrivilegesOfAdminUserGroups = "sp_AdminUserGroups_DeleteAllPrivileges";
            //

            //AdminMenu
            public const string InsertAdminMenu = "sp_AdminMenu_Insert";
            public const string GetAllAdminMenu = "sp_AdminMenu_Select_All";
            public const string GetAdminMenuByID = "sp_AdminMenu_Select_By_MenuID";
            public const string GetAdminMenuByUserID = "sp_AdminMenu_Select_By_UserID";
            public const string GetAdminMenuByUserName = "sp_AdminMenu_Select_By_UserName";
            public const string GetAdminMenuByCode = "sp_AdminMenu_Select_By_Code";
            public const string UpdateAdminMenu = "sp_AdminMenu_Update";
            public const string GetAdminMenuByUserGroupID = "sp_AdminMenu_Select_By_UserGroupID";
            //AdminActions
            public const string InsertAdminAction = "sp_AdminActions_Insert";
            public const string GetAllAdminActions = "sp_AdminActions_Select_All";
            public const string GetAdminActionByID = "sp_AdminActions_Select_By_ActionID";
            public const string GetAdminActionByUserID = "sp_AdminActions_Select_By_UserID";
            public const string GetAdminActionByUserName = "sp_AdminActions_Select_By_UserName";
            public const string GetAdminActionByCode = "sp_AdminActions_Select_By_Code";
            public const string UpdateAdminAction = "sp_AdminActions_Update";
            public const string GetAdminActionByUserGroupID = "sp_AdminActions_Select_By_UserGroupID";
            //AdminActionGroups
            public const string InsertAdminActionGroup = "sp_AdminActionGroups_Insert";
            public const string GetAllAdminActionGroups = "sp_AdminActionGroups_Select_All";
            public const string GetAdminActionGroupByID = "sp_AdminActionGroups_Select_By_ID";
            public const string GetAdminActionGroupByCode = "sp_AdminActionGroups_Select_By_Code";
            public const string UpdateAdminActionGroup = "sp_AdminActionGroups_Update";

        }
    }
}
